package com.example.wotu;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import android.os.Bundle;

import androidx.annotation.Nullable;
import androidx.fragment.app.Fragment;

import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.view.inputmethod.InputMethodManager;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.TextView;
import android.widget.Toast;


/**
 * A simple {@link Fragment} subclass.
 * Activities that contain this fragment must implement the
 * {@link FragBookCont.OnFragmentInteractionListener} interface
 * to handle interaction events.
 * Use the {@link FragBookCont#newInstance} factory method to
 * create an instance of this fragment.
 */
public class FragBookCont extends Fragment {
    // TODO: Rename parameter arguments, choose names that match
    // the fragment initialization parameters, e.g. ARG_ITEM_NUMBER
    private static final String ARG_PARAM1 = "param1";
    private static final String ARG_PARAM2 = "param2";

    // TODO: Rename and change types of parameters
    private String mParam1;
    private String mParam2;

    private OnFragmentInteractionListener mListener;
    private View view;
    private SQLiteDatabase sql;
    private int cheid;
    private TextView Aa;
    private ImageView Bb;
    private EditText Cc;

    public FragBookCont() {
        // Required empty public constructor
    }

    /**
     * Use this factory method to create a new instance of
     * this fragment using the provided parameters.
     *
     * @param param1 Parameter 1.
     * @param param2 Parameter 2.
     * @return A new instance of fragment FragBookCont.
     */
    // TODO: Rename and change types and number of parameters
    public static FragBookCont newInstance(String param1, String param2) {
        FragBookCont fragment = new FragBookCont();
        Bundle args = new Bundle();
        args.putString(ARG_PARAM1, param1);
        args.putString(ARG_PARAM2, param2);
        fragment.setArguments(args);
        return fragment;
    }

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        if (getArguments() != null) {
            mParam1 = getArguments().getString(ARG_PARAM1);
            mParam2 = getArguments().getString(ARG_PARAM2);
        }
    }

    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {
        // Inflate the layout for this fragment
        view = inflater.inflate(R.layout.frag_book_cont, container, false);
        return view;
    }

    @Override
    public void onActivityCreated(@Nullable Bundle savedInstanceState) {
        super.onActivityCreated(savedInstanceState);
        mListener.onNOT_WK(106);
        cheid = getArguments().getInt("chid");
        //顺序问题出现错误！
        getFind();
        getSQLConts(0);
    }

    private void getFind(){
        Aa = (TextView)view.findViewById(R.id.Aa);
        Bb = (ImageView)view.findViewById(R.id.Ab);
        Cc = (EditText)view.findViewById(R.id.Ac);
        Bb.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                getSQLConts(1);
                JIANP();
            }
        });
    }
    private void getSQLConts(int g){
        String Ta="",Tb="";
        if(g == 0){
            sql = new MySQLOpen(getActivity()).getReadableDatabase();
            try{
                Cursor cs = sql.rawQuery("select chapname,content from chapter where chapterid = ?",new String[]{String.valueOf(cheid)});
                while (cs.moveToNext()){
                    Ta = cs.getString(0);
                    Tb = cs.getString(1);
                    break;
                }
                sql.close();
            }catch (Exception e){
                e.printStackTrace();
                Toast.makeText(getActivity(),"数据错误！",Toast.LENGTH_SHORT).show();
                sql.close();
            }
            Aa.setText(String.valueOf(Ta));
            if(Tb != null) Cc.setText(String.valueOf(Tb));
        }
        else if(g == 1){
            sql = new MySQLOpen(getActivity()).getReadableDatabase();
            try{
                ContentValues cvs = new ContentValues();
                cvs.put("content",Cc.getText().toString());
                sql.update("chapter",cvs,"chapterid = ?",new String[]{String.valueOf(cheid)});
                Toast.makeText(getActivity(),"已保存！",Toast.LENGTH_SHORT).show();
                sql.close();
            }catch (Exception e){
                e.printStackTrace();
                Toast.makeText(getActivity(),"数据错误！",Toast.LENGTH_SHORT).show();
                sql.close();
            }
        }
    }
    private void JIANP(){
        //键盘问题
        InputMethodManager imm = (InputMethodManager) view.getContext().getSystemService(Context.INPUT_METHOD_SERVICE);
        imm.hideSoftInputFromWindow(view.getWindowToken(), InputMethodManager.HIDE_NOT_ALWAYS);
    }

    // TODO: Rename method, update argument and hook method into UI event
    public void onButtonPressed(Uri uri) {
        if (mListener != null) {
            mListener.onFragmentInteraction(uri);
        }
    }

    @Override
    public void onAttach(Context context) {
        super.onAttach(context);
        if (context instanceof OnFragmentInteractionListener) {
            mListener = (OnFragmentInteractionListener) context;
        } else {
            throw new RuntimeException(context.toString()
                    + " must implement OnFragmentInteractionListener");
        }
    }

    @Override
    public void onDetach() {
        super.onDetach();
        mListener = null;
    }

    /**
     * This interface must be implemented by activities that contain this
     * fragment to allow an interaction in this fragment to be communicated
     * to the activity and potentially other fragments contained in that
     * activity.
     * <p>
     * See the Android Training lesson <a href=
     * "http://developer.android.com/training/basics/fragments/communicating.html"
     * >Communicating with Other Fragments</a> for more information.
     */
    public interface OnFragmentInteractionListener {
        // TODO: Update argument type and name
        void onFragmentInteraction(Uri uri);
        void onNOT_WK(int wk);
    }
}
